<?php

class Application_Model_DbTable_ZFNewsCountry extends Zend_Db_Table_Abstract
{

	protected $_name = 'zf_news_country';

	public function deleteAllCountrysForNews($newsId)
	{
		$select = $this->_db->delete($this->_name, 'news_id = ' . $newsId);
              #  select()
	#	->from($this->_name)
	#	->where('news_id = ?',$newsId);
	#	$results = $this->getAdapter()->fetchAll($select);
		// addEmptyElement for dropdowns
	#	return $results;
/*
->fetchAll($select);
 [0] => array(2) {
    ["code_country"] => string(2) "CA"
    ["name_en"] => string(6) "Canada"
  }
 [1] => array(2) {
    ["code_country"] => string(2) "FR"
    ["name_en"] => string(6) "France"
  }
*/
		#->fetchRow($select);
/*
->fetchPairs($select);
["CA"] => string(6) "Canada"
["FR"] => string(6) "France"
["BR"] => string(6) "Brazil"
*/

	}
/*
	public function getAllArticlesForCountry($country)
	{
		$select = $this->_db->select()
		->from($this->_name,array('news_id','title','short_news','long_news','dest_lang', 'pub_date', 'picture', 'published'))
		#->where('approved = ?',0)
		->where('dest_country = ?',$country)
		->order('insert_time DESC');
		$results = $this->getAdapter()->fetchAll($select);
		// addEmptyElement for dropdowns
		return $results;
	}
 * 
 */
}